package com.tanhua.admin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lych.model.domain.Log;
import feign.Param;
import org.apache.ibatis.annotations.Select;


public interface LogMapper extends BaseMapper<Log> {
    //根据时间与类型
    @Select("select count(distinct user_id) from tb_log where type=#{type} and log_time=#{logTime}")
    Integer queryWithTimeType(@Param("type") String type, @Param("logTime") String logTime);

    //根据时间查询
    @Select("select count(distinct user_id) from tb_log where log_time=#{logTime}")
    Integer queryWithTime(String logTime);

    //查询次日留存
    @Select("SELECT COUNT(DISTINCT user_id)  FROM tb_log WHERE log_time=#{today} AND user_id IN (\n " +
            " SELECT user_id FROM tb_log WHERE TYPE=\"0102\" AND log_time=#{yestoday} \n " +
            ")")
    Integer queryNumRetention1d(@Param("today")  String today,@Param("yestoday") String yestoday);

}
